# -*- coding: utf-8 -*-
# @Time    : 2024/12/9  15:36
# @Author  : Nabby
# @FileName: jasco_forecast_information.py
# @Desc    : 货物预报信息


from app import db, loginmanager
from datetime import datetime


class JascoLoadingOrder(db.Model):
    __tablename__ = 'jasco_loading_order'
    id = db.Column(db.Integer, primary_key=True)
    container_number = db.Column(db.String(50), unique=True, comment='货箱编号')
    english_name = db.Column(db.String(50), comment='英文品名')
    chinese_name = db.Column(db.String(50), comment='中文品名')
    customs_code = db.Column(db.String(30), comment='海关编码')
    products_num = db.Column(db.String(20), comment='数量')
    chinese_material = db.Column(db.String(50), comment='中文材质')
    english_material = db.Column(db.String(50), comment='英文材质')
    chinese_use = db.Column(db.String(50), comment='中文用途')
    english_use = db.Column(db.String(50), comment='英文用途')
    brand = db.Column(db.String(50), comment='品牌')
    model = db.Column(db.String(50), comment='型号')
    unit = db.Column(db.String(20), comment='单位')
    price = db.Column(db.String(20), comment='单价')
    currency = db.Column(db.String(50), comment='币种')
    total_price = db.Column(db.String(50), comment='总价')
    net_weight = db.Column(db.String(50), comment='净重')
    source_area = db.Column(db.String(50), comment='原产地')
    final_destination = db.Column(db.String(50), comment='最终目的国')
    declaration_information_id = db.Column(db.Integer, db.ForeignKey('jasco_declaration_information.id'), comment='申报信息id')
    create_time = db.Column(db.DateTime, default=datetime.now)
    update_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)



